package net.itst.schwarzerdaumen;

public interface TablePlants {

    /**
     * The name of this table: <i>plants</i>
     */
    String TABLE_NAME = "plants";

    String ID = "_id";
    String NAME = "name";
    String IMAGE = "image";
    String MON = "mon";
    String TUE = "tue";
    String WED = "wed";
    String THU = "thu";
    String FRI = "fri";
    String SAT = "sat";
    String SUN = "sun";
    String WNEXT = "w_next";

    String[] SQL_GET_DAYS = { MON, TUE, WED, THU, FRI, SAT, SUN };

    String[] SQL_GET_ALL = { ID, NAME, IMAGE, MON, TUE, WED, THU, FRI, SAT,
	    SUN, WNEXT };

    String[] SQL_GET_STATUS = { ID, NAME, IMAGE, WNEXT };

    String[] FIELDS_GET_STATUS = { NAME, IMAGE, WNEXT };

    String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + " (" + ID
	    + " INTEGER PRIMARY KEY AUTOINCREMENT," + NAME + " TEXT NOT NULL,"
	    + IMAGE + " TEXT," + MON + " INTEGER DEFAULT 0, " + TUE
	    + " INTEGER DEFAULT 0, " + WED + " INTEGER DEFAULT 0, " + THU
	    + " INTEGER DEFAULT 0, " + FRI + " INTEGER DEFAULT 0, " + SAT
	    + " INTEGER DEFAULT 0, " + SUN + " INTEGER DEFAULT 0, " + WNEXT
	    + " TEXT);";
}
